SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO



CREATE PROCEDURE [dbo].[usp_AddApplyField]
    (
      @JOL_Field_ApplyCompany VARCHAR(50) ,
      @JOL_Field_Purpose VARCHAR(50) ,--场地用途
      @JOL_Field_Linkman VARCHAR(50) ,--联系人
      @JOL_Field_Contact VARCHAR(50) ,--联系方式
      @JOL_Field_Action VARCHAR(100) ,--活动
      @JOL_Field_ApplyTime DATETIME ,--时间
      @JOL_Field_ApplyPosition VARCHAR(50) ,--地点
      @JOL_Field_SeatNumber INT ,--人数
      @JOL_Field_IsProvideMultimedia BIT ,--是否使用多媒体
      @JOL_Field_IsNeedInvoice BIT ,--是否需要发票
      @JOL_Field_InvoiceBeginning VARCHAR(50) ,--发票开头
      @JOL_Field_InvoiceProject VARCHAR(50) ,--发票项目
      @JOL_Field_IsPaidMoney BIT ,--是否已缴费，中心管理员填写
      @JOL_Field_AddTime DATETIME ,--更新时间
      @JOL_Field_AddUser VARCHAR(50) ,--更新账户
      @JOL_Field_Remark NTEXT ,--备注	
      @JOL_ApplyField_EndTime DATETIME ,
      @JOL_ApplyField_Phone VARCHAR(50) ,
      @JOL_ApplyField_Fax VARCHAR(50) ,
      @JOL_ApplyField_Email VARCHAR(50),
      @JOL_ApplyField_VerifyStatus VARCHAR(50),
      @JOL_ApplyField_VerifyUser VARCHAR(50)
    )
AS 
    INSERT  INTO dbo.JOL_ApplyField
            ( JOL_Field_ApplyCompany ,
              JOL_Field_Purpose ,
              JOL_Field_Linkman ,
              JOL_Field_Contact ,
              JOL_Field_Action ,
              JOL_Field_ApplyTime ,
              JOL_Field_ApplyPosition ,
              JOL_Field_SeatNumber ,
              JOL_Field_IsProvideMultimedia ,
              JOL_Field_IsNeedInvoice ,
              JOL_Field_InvoiceBeginning ,
              JOL_Field_InvoiceProject ,
              JOL_Field_IsPaidMoney ,
              JOL_Field_AddTime ,
              JOL_Field_AddUser ,
              JOL_Field_UpdateTime ,
              JOL_Field_UpdateUser ,
              JOL_Field_VerifyStatus ,
              JOL_Field_VerifyUser ,
              JOL_Field_IsSendEmail ,
              JOL_Field_Remark ,
              JOL_ApplyField_EndTime ,
              JOL_ApplyField_Phone ,
              JOL_ApplyField_Fax ,
              JOL_ApplyField_Email
            )
    VALUES  ( @JOL_Field_ApplyCompany , -- JOL_Field_ApplyCompany - varchar(50)
              @JOL_Field_Purpose , -- JOL_Field_Purpose - varchar(50)
              @JOL_Field_Linkman , -- JOL_Field_Linkman - varchar(50)
              @JOL_Field_Contact , -- JOL_Field_Contact - varchar(50)
              @JOL_Field_Action , -- JOL_Field_Action - varchar(100)
              @JOL_Field_ApplyTime , -- JOL_Field_ApplyTime - datetime
              @JOL_Field_ApplyPosition , -- JOL_Field_ApplyPosition - varchar(50)
              @JOL_Field_SeatNumber , -- JOL_Field_SeatNumber - int
              @JOL_Field_IsProvideMultimedia , -- JOL_Field_IsProvideMultimedia - bit
              @JOL_Field_IsNeedInvoice , -- JOL_Field_IsNeedInvoice - bit
              @JOL_Field_InvoiceBeginning , -- JOL_Field_InvoiceBeginning - varchar(50)
              @JOL_Field_InvoiceProject , -- JOL_Field_InvoiceProject - varchar(50)
              @JOL_Field_IsPaidMoney , -- JOL_Field_IsPaidMoney - bit
              GETDATE() , -- JOL_Field_AddTime - datetime
              @JOL_Field_AddUser , -- JOL_Field_AddUser - varchar(50)
              NULL , -- JOL_Field_UpdateTime - datetime
              NULL , -- JOL_Field_UpdateUser - varchar(50)
              @JOL_ApplyField_VerifyStatus , -- JOL_Field_VerifyStatus - varchar(50)
              @JOL_ApplyField_VerifyUser , -- JOL_Field_VerifyUser - varchar(50)
              0 , -- JOL_Field_IsSendEmail - bit
              @JOL_Field_Remark ,  -- JOL_Field_Remark - ntext
              @JOL_ApplyField_EndTime ,
              @JOL_ApplyField_Phone ,
              @JOL_ApplyField_Fax ,
              @JOL_ApplyField_Email
            )



GO
